# mysqldump --user=root --password=1 tm > tm.sql.

# mysqldump --user=root --password=1 tm2 | pv | gzip >  tm2-$(date +%Y%m%d).sql.gz

DB=mcc

mysqldump --user=root --password=1 \
--ignore-table=${DB}.s5eventblob \
--ignore-table=${DB}.s5eventblock \
--ignore-table=${DB}.s5commandblob \
--ignore-table=${DB}.s5commandblock \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity0 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity1 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity2 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity3 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity4 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity5 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity6 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity7 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity8 \
--ignore-table=${DB}.s5histdataasyncbooleanblobentity9 \
--ignore-table=${DB}.s5histdataasyncbooleanentity0 \
--ignore-table=${DB}.s5histdataasyncbooleanentity1 \
--ignore-table=${DB}.s5histdataasyncbooleanentity2 \
--ignore-table=${DB}.s5histdataasyncbooleanentity3 \
--ignore-table=${DB}.s5histdataasyncbooleanentity4 \
--ignore-table=${DB}.s5histdataasyncbooleanentity5 \
--ignore-table=${DB}.s5histdataasyncbooleanentity6 \
--ignore-table=${DB}.s5histdataasyncbooleanentity7 \
--ignore-table=${DB}.s5histdataasyncbooleanentity8 \
--ignore-table=${DB}.s5histdataasyncbooleanentity9 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity0 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity1 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity2 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity3 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity4 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity5 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity6 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity7 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity8 \
--ignore-table=${DB}.s5histdataasyncvalobjblobentity9 \
--ignore-table=${DB}.s5histdataasyncvalobjentity0 \
--ignore-table=${DB}.s5histdataasyncvalobjentity1 \
--ignore-table=${DB}.s5histdataasyncvalobjentity2 \
--ignore-table=${DB}.s5histdataasyncvalobjentity3 \
--ignore-table=${DB}.s5histdataasyncvalobjentity4 \
--ignore-table=${DB}.s5histdataasyncvalobjentity5 \
--ignore-table=${DB}.s5histdataasyncvalobjentity6 \
--ignore-table=${DB}.s5histdataasyncvalobjentity7 \
--ignore-table=${DB}.s5histdataasyncvalobjentity8 \
--ignore-table=${DB}.s5histdataasyncvalobjentity9 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity0 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity1 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity2 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity3 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity4 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity5 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity6 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity7 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity8 \
--ignore-table=${DB}.s5histdataasyncfloatingblobentity9 \
--ignore-table=${DB}.s5histdataasyncfloatingentity0 \
--ignore-table=${DB}.s5histdataasyncfloatingentity1 \
--ignore-table=${DB}.s5histdataasyncfloatingentity2 \
--ignore-table=${DB}.s5histdataasyncfloatingentity3 \
--ignore-table=${DB}.s5histdataasyncfloatingentity4 \
--ignore-table=${DB}.s5histdataasyncfloatingentity5 \
--ignore-table=${DB}.s5histdataasyncfloatingentity6 \
--ignore-table=${DB}.s5histdataasyncfloatingentity7 \
--ignore-table=${DB}.s5histdataasyncfloatingentity8 \
--ignore-table=${DB}.s5histdataasyncfloatingentity9 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity0 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity1 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity2 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity3 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity4 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity5 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity6 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity7 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity8 \
--ignore-table=${DB}.s5histdataasyncintegerblobentity9 \
--ignore-table=${DB}.s5histdataasyncintegerentity0 \
--ignore-table=${DB}.s5histdataasyncintegerentity1 \
--ignore-table=${DB}.s5histdataasyncintegerentity2 \
--ignore-table=${DB}.s5histdataasyncintegerentity3 \
--ignore-table=${DB}.s5histdataasyncintegerentity4 \
--ignore-table=${DB}.s5histdataasyncintegerentity5 \
--ignore-table=${DB}.s5histdataasyncintegerentity6 \
--ignore-table=${DB}.s5histdataasyncintegerentity7 \
--ignore-table=${DB}.s5histdataasyncintegerentity8 \
--ignore-table=${DB}.s5histdataasyncintegerentity9 \
--ignore-table=${DB}.s5histdataasyncstringblobentity0 \
--ignore-table=${DB}.s5histdataasyncstringblobentity1 \
--ignore-table=${DB}.s5histdataasyncstringblobentity2 \
--ignore-table=${DB}.s5histdataasyncstringblobentity3 \
--ignore-table=${DB}.s5histdataasyncstringblobentity4 \
--ignore-table=${DB}.s5histdataasyncstringblobentity5 \
--ignore-table=${DB}.s5histdataasyncstringblobentity6 \
--ignore-table=${DB}.s5histdataasyncstringblobentity7 \
--ignore-table=${DB}.s5histdataasyncstringblobentity8 \
--ignore-table=${DB}.s5histdataasyncstringblobentity9 \
--ignore-table=${DB}.s5histdataasyncstringentity0 \
--ignore-table=${DB}.s5histdataasyncstringentity1 \
--ignore-table=${DB}.s5histdataasyncstringentity2 \
--ignore-table=${DB}.s5histdataasyncstringentity3 \
--ignore-table=${DB}.s5histdataasyncstringentity4 \
--ignore-table=${DB}.s5histdataasyncstringentity5 \
--ignore-table=${DB}.s5histdataasyncstringentity6 \
--ignore-table=${DB}.s5histdataasyncstringentity7 \
--ignore-table=${DB}.s5histdataasyncstringentity8 \
--ignore-table=${DB}.s5histdataasyncstringentity9 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity0 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity1 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity2 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity3 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity4 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity5 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity6 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity7 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity8 \
--ignore-table=${DB}.s5histdataasynctimestampblobentity9 \
--ignore-table=${DB}.s5histdataasynctimestampentity0 \
--ignore-table=${DB}.s5histdataasynctimestampentity1 \
--ignore-table=${DB}.s5histdataasynctimestampentity2 \
--ignore-table=${DB}.s5histdataasynctimestampentity3 \
--ignore-table=${DB}.s5histdataasynctimestampentity4 \
--ignore-table=${DB}.s5histdataasynctimestampentity5 \
--ignore-table=${DB}.s5histdataasynctimestampentity6 \
--ignore-table=${DB}.s5histdataasynctimestampentity7 \
--ignore-table=${DB}.s5histdataasynctimestampentity8 \
--ignore-table=${DB}.s5histdataasynctimestampentity9 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity0 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity1 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity2 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity3 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity4 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity5 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity6 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity7 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity8 \
--ignore-table=${DB}.s5histdatasyncbooleanblobentity9 \
--ignore-table=${DB}.s5histdatasyncbooleanentity0 \
--ignore-table=${DB}.s5histdatasyncbooleanentity1 \
--ignore-table=${DB}.s5histdatasyncbooleanentity2 \
--ignore-table=${DB}.s5histdatasyncbooleanentity3 \
--ignore-table=${DB}.s5histdatasyncbooleanentity4 \
--ignore-table=${DB}.s5histdatasyncbooleanentity5 \
--ignore-table=${DB}.s5histdatasyncbooleanentity6 \
--ignore-table=${DB}.s5histdatasyncbooleanentity7 \
--ignore-table=${DB}.s5histdatasyncbooleanentity8 \
--ignore-table=${DB}.s5histdatasyncbooleanentity9 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity0 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity1 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity2 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity3 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity4 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity5 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity6 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity7 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity8 \
--ignore-table=${DB}.s5histdatasyncvalobjblobentity9 \
--ignore-table=${DB}.s5histdatasyncvalobjentity0 \
--ignore-table=${DB}.s5histdatasyncvalobjentity1 \
--ignore-table=${DB}.s5histdatasyncvalobjentity2 \
--ignore-table=${DB}.s5histdatasyncvalobjentity3 \
--ignore-table=${DB}.s5histdatasyncvalobjentity4 \
--ignore-table=${DB}.s5histdatasyncvalobjentity5 \
--ignore-table=${DB}.s5histdatasyncvalobjentity6 \
--ignore-table=${DB}.s5histdatasyncvalobjentity7 \
--ignore-table=${DB}.s5histdatasyncvalobjentity8 \
--ignore-table=${DB}.s5histdatasyncvalobjentity9 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity0 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity1 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity2 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity3 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity4 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity5 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity6 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity7 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity8 \
--ignore-table=${DB}.s5histdatasyncfloatingblobentity9 \
--ignore-table=${DB}.s5histdatasyncfloatingentity0 \
--ignore-table=${DB}.s5histdatasyncfloatingentity1 \
--ignore-table=${DB}.s5histdatasyncfloatingentity2 \
--ignore-table=${DB}.s5histdatasyncfloatingentity3 \
--ignore-table=${DB}.s5histdatasyncfloatingentity4 \
--ignore-table=${DB}.s5histdatasyncfloatingentity5 \
--ignore-table=${DB}.s5histdatasyncfloatingentity6 \
--ignore-table=${DB}.s5histdatasyncfloatingentity7 \
--ignore-table=${DB}.s5histdatasyncfloatingentity8 \
--ignore-table=${DB}.s5histdatasyncfloatingentity9 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity0 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity1 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity2 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity3 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity4 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity5 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity6 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity7 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity8 \
--ignore-table=${DB}.s5histdatasyncintegerblobentity9 \
--ignore-table=${DB}.s5histdatasyncintegerentity0 \
--ignore-table=${DB}.s5histdatasyncintegerentity1 \
--ignore-table=${DB}.s5histdatasyncintegerentity2 \
--ignore-table=${DB}.s5histdatasyncintegerentity3 \
--ignore-table=${DB}.s5histdatasyncintegerentity4 \
--ignore-table=${DB}.s5histdatasyncintegerentity5 \
--ignore-table=${DB}.s5histdatasyncintegerentity6 \
--ignore-table=${DB}.s5histdatasyncintegerentity7 \
--ignore-table=${DB}.s5histdatasyncintegerentity8 \
--ignore-table=${DB}.s5histdatasyncintegerentity9 \
--ignore-table=${DB}.s5histdatasyncstringblobentity0 \
--ignore-table=${DB}.s5histdatasyncstringblobentity1 \
--ignore-table=${DB}.s5histdatasyncstringblobentity2 \
--ignore-table=${DB}.s5histdatasyncstringblobentity3 \
--ignore-table=${DB}.s5histdatasyncstringblobentity4 \
--ignore-table=${DB}.s5histdatasyncstringblobentity5 \
--ignore-table=${DB}.s5histdatasyncstringblobentity6 \
--ignore-table=${DB}.s5histdatasyncstringblobentity7 \
--ignore-table=${DB}.s5histdatasyncstringblobentity8 \
--ignore-table=${DB}.s5histdatasyncstringblobentity9 \
--ignore-table=${DB}.s5histdatasyncstringentity0 \
--ignore-table=${DB}.s5histdatasyncstringentity1 \
--ignore-table=${DB}.s5histdatasyncstringentity2 \
--ignore-table=${DB}.s5histdatasyncstringentity3 \
--ignore-table=${DB}.s5histdatasyncstringentity4 \
--ignore-table=${DB}.s5histdatasyncstringentity5 \
--ignore-table=${DB}.s5histdatasyncstringentity6 \
--ignore-table=${DB}.s5histdatasyncstringentity7 \
--ignore-table=${DB}.s5histdatasyncstringentity8 \
--ignore-table=${DB}.s5histdatasyncstringentity9 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity0 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity1 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity2 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity3 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity4 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity5 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity6 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity7 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity8 \
--ignore-table=${DB}.s5histdatasynctimestampblobentity9 \
--ignore-table=${DB}.s5histdatasynctimestampentity0 \
--ignore-table=${DB}.s5histdatasynctimestampentity1 \
--ignore-table=${DB}.s5histdatasynctimestampentity2 \
--ignore-table=${DB}.s5histdatasynctimestampentity3 \
--ignore-table=${DB}.s5histdatasynctimestampentity4 \
--ignore-table=${DB}.s5histdatasynctimestampentity5 \
--ignore-table=${DB}.s5histdatasynctimestampentity6 \
--ignore-table=${DB}.s5histdatasynctimestampentity7 \
--ignore-table=${DB}.s5histdatasynctimestampentity8 \
--ignore-table=${DB}.s5histdatasynctimestampentity9 \
${DB} > mcc_nodata-$(date +%Y-%m-%d).sql
